CREATE      PROC [dbo].[asi_ExpireTimedCommitments]
    @ProductKey uniqueidentifier
    AS
BEGIN
    -- Set nocount option to surpress row count messages
    SET NOCOUNT ON
    -- Declare variables
    DECLARE @whereClause nvarchar(50)
    SET @whereClause = ' '
    IF @ProductKey is not null
    BEGIN
        SET @whereClause = ' and ProductKey = ''' + cast(@ProductKey as nchar(36)) + ''''
    END

    DELETE FROM Commitment WHERE ExpirationDate < GETDATE() + @whereClause
END

GO